Does my approach for building a real time monitoring system make sense? [closed]
Posted
by
sameer
on Programmers
See other posts from Programmers
or by sameer
Published on 2012-12-13T18:57:39Z
Indexed on
2012/12/16
23:19 UTC
Read the original article
Hit count: 256
I am developing an application that will display a dashboard that will display data from different SQL databases. This needs to happen in almost real time, our refresh time is about 5 minutes. My approach so far is:
- Develop a Windows service to accumulate the data from various SQL Server instances.
- Persist those details into a SQL DB, from which the dashboard will display them on the web page.
- Trigger fetching of data from the Windows service will every x minutes.
- The details of the SQL Server instances will be stored in the SQL DB which the Windows service will be referring.
Does my approach make sense?
© Programmers or respective owner